'Usage Dim instance As CalcMIrrFunction Dim args() As Object Dim value As Object value = instance.Evaluate(args)
Parameters
- args
The args contains 3 items: values, finance_rate, reinvest_rate.
Values is an array or a reference to cells that contain numbers. These numbers represent a series of payments (negative values) and income (positive values) occurring at regular periods.
Finance_rate is the interest rate you pay on the money used in the cash flows.
Reinvest_rate is the interest rate you receive on the cash flows as you reinvest them.